Week Dates - Get the first and last dates in a week

This action gets a year and a week number in the year and returns the first and last dates in the specified week.

Weeks are numbered according to the ISO-8601 definitions (as presented by Tondering): First day of the week is Monday, and a week belongs to the year in which most of its days lie. E.g. since 2004 started on Wednesday, the 1st week of 2004 started on 29-Dec-2003 and ended on 4-Jan-2004 (3 days in 2003, 4 days in 2004).

Triggers

<Year> (non-repetitive numeric trigger [required]): A year (e.g. 2004).

<Week Number> (non-repetitive numeric trigger [required]): The week in the year (usually 1 through 52 or 1 through 53, depending on the year, but "lenient" values are also acceptable, so 0, for example, refers to "the week before the first week of the year").

<First Day> (non-repetitive trigger [not required]): "Sunday" to specify that the first day of the week is Sunday (if the trigger is missing, the default Monday is used).

Exits [none required]

<First Date> (non-repetitive date exit [not required]): The date of the first day in the specified week.

<Last Date> (non-repetitive date exit [not required]): The date of the last day in the specified week.

<<Year>> (non-repetitive numeric exit [not required]): The year to which the week belongs (might be different from <Year> if a "lenient" value has been specified).

<<Week Number>> (non-repetitive numeric exit [not required]): The week in the year (1 through 52 or 1 through 53, depending on the year; might be different from <Week Number> if a "lenient" value has been specified).

Usage Examples

Test1 (need to complete)